package com.guosheng.pojo;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class SysCardInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public SysCardInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andCardidIsNull() {
            addCriterion("cardID is null");
            return (Criteria) this;
        }

        public Criteria andCardidIsNotNull() {
            addCriterion("cardID is not null");
            return (Criteria) this;
        }

        public Criteria andCardidEqualTo(String value) {
            addCriterion("cardID =", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotEqualTo(String value) {
            addCriterion("cardID <>", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidGreaterThan(String value) {
            addCriterion("cardID >", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidGreaterThanOrEqualTo(String value) {
            addCriterion("cardID >=", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidLessThan(String value) {
            addCriterion("cardID <", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidLessThanOrEqualTo(String value) {
            addCriterion("cardID <=", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidLike(String value) {
            addCriterion("cardID like", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotLike(String value) {
            addCriterion("cardID not like", value, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidIn(List<String> values) {
            addCriterion("cardID in", values, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotIn(List<String> values) {
            addCriterion("cardID not in", values, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidBetween(String value1, String value2) {
            addCriterion("cardID between", value1, value2, "cardid");
            return (Criteria) this;
        }

        public Criteria andCardidNotBetween(String value1, String value2) {
            addCriterion("cardID not between", value1, value2, "cardid");
            return (Criteria) this;
        }

        public Criteria andCurtypeIsNull() {
            addCriterion("curType is null");
            return (Criteria) this;
        }

        public Criteria andCurtypeIsNotNull() {
            addCriterion("curType is not null");
            return (Criteria) this;
        }

        public Criteria andCurtypeEqualTo(String value) {
            addCriterion("curType =", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeNotEqualTo(String value) {
            addCriterion("curType <>", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeGreaterThan(String value) {
            addCriterion("curType >", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeGreaterThanOrEqualTo(String value) {
            addCriterion("curType >=", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeLessThan(String value) {
            addCriterion("curType <", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeLessThanOrEqualTo(String value) {
            addCriterion("curType <=", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeLike(String value) {
            addCriterion("curType like", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeNotLike(String value) {
            addCriterion("curType not like", value, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeIn(List<String> values) {
            addCriterion("curType in", values, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeNotIn(List<String> values) {
            addCriterion("curType not in", values, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeBetween(String value1, String value2) {
            addCriterion("curType between", value1, value2, "curtype");
            return (Criteria) this;
        }

        public Criteria andCurtypeNotBetween(String value1, String value2) {
            addCriterion("curType not between", value1, value2, "curtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeIsNull() {
            addCriterion("savingType is null");
            return (Criteria) this;
        }

        public Criteria andSavingtypeIsNotNull() {
            addCriterion("savingType is not null");
            return (Criteria) this;
        }

        public Criteria andSavingtypeEqualTo(String value) {
            addCriterion("savingType =", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeNotEqualTo(String value) {
            addCriterion("savingType <>", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeGreaterThan(String value) {
            addCriterion("savingType >", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeGreaterThanOrEqualTo(String value) {
            addCriterion("savingType >=", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeLessThan(String value) {
            addCriterion("savingType <", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeLessThanOrEqualTo(String value) {
            addCriterion("savingType <=", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeLike(String value) {
            addCriterion("savingType like", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeNotLike(String value) {
            addCriterion("savingType not like", value, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeIn(List<String> values) {
            addCriterion("savingType in", values, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeNotIn(List<String> values) {
            addCriterion("savingType not in", values, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeBetween(String value1, String value2) {
            addCriterion("savingType between", value1, value2, "savingtype");
            return (Criteria) this;
        }

        public Criteria andSavingtypeNotBetween(String value1, String value2) {
            addCriterion("savingType not between", value1, value2, "savingtype");
            return (Criteria) this;
        }

        public Criteria andOpendateIsNull() {
            addCriterion("openDate is null");
            return (Criteria) this;
        }

        public Criteria andOpendateIsNotNull() {
            addCriterion("openDate is not null");
            return (Criteria) this;
        }

        public Criteria andOpendateEqualTo(Date value) {
            addCriterionForJDBCDate("openDate =", value, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateNotEqualTo(Date value) {
            addCriterionForJDBCDate("openDate <>", value, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateGreaterThan(Date value) {
            addCriterionForJDBCDate("openDate >", value, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("openDate >=", value, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateLessThan(Date value) {
            addCriterionForJDBCDate("openDate <", value, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("openDate <=", value, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateIn(List<Date> values) {
            addCriterionForJDBCDate("openDate in", values, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateNotIn(List<Date> values) {
            addCriterionForJDBCDate("openDate not in", values, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("openDate between", value1, value2, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpendateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("openDate not between", value1, value2, "opendate");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyIsNull() {
            addCriterion("openMoney is null");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyIsNotNull() {
            addCriterion("openMoney is not null");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyEqualTo(Long value) {
            addCriterion("openMoney =", value, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyNotEqualTo(Long value) {
            addCriterion("openMoney <>", value, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyGreaterThan(Long value) {
            addCriterion("openMoney >", value, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("openMoney >=", value, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyLessThan(Long value) {
            addCriterion("openMoney <", value, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyLessThanOrEqualTo(Long value) {
            addCriterion("openMoney <=", value, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyIn(List<Long> values) {
            addCriterion("openMoney in", values, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyNotIn(List<Long> values) {
            addCriterion("openMoney not in", values, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyBetween(Long value1, Long value2) {
            addCriterion("openMoney between", value1, value2, "openmoney");
            return (Criteria) this;
        }

        public Criteria andOpenmoneyNotBetween(Long value1, Long value2) {
            addCriterion("openMoney not between", value1, value2, "openmoney");
            return (Criteria) this;
        }

        public Criteria andBalanceIsNull() {
            addCriterion("balance is null");
            return (Criteria) this;
        }

        public Criteria andBalanceIsNotNull() {
            addCriterion("balance is not null");
            return (Criteria) this;
        }

        public Criteria andBalanceEqualTo(Long value) {
            addCriterion("balance =", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotEqualTo(Long value) {
            addCriterion("balance <>", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceGreaterThan(Long value) {
            addCriterion("balance >", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceGreaterThanOrEqualTo(Long value) {
            addCriterion("balance >=", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceLessThan(Long value) {
            addCriterion("balance <", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceLessThanOrEqualTo(Long value) {
            addCriterion("balance <=", value, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceIn(List<Long> values) {
            addCriterion("balance in", values, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotIn(List<Long> values) {
            addCriterion("balance not in", values, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceBetween(Long value1, Long value2) {
            addCriterion("balance between", value1, value2, "balance");
            return (Criteria) this;
        }

        public Criteria andBalanceNotBetween(Long value1, Long value2) {
            addCriterion("balance not between", value1, value2, "balance");
            return (Criteria) this;
        }

        public Criteria andPassIsNull() {
            addCriterion("pass is null");
            return (Criteria) this;
        }

        public Criteria andPassIsNotNull() {
            addCriterion("pass is not null");
            return (Criteria) this;
        }

        public Criteria andPassEqualTo(String value) {
            addCriterion("pass =", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassNotEqualTo(String value) {
            addCriterion("pass <>", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassGreaterThan(String value) {
            addCriterion("pass >", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassGreaterThanOrEqualTo(String value) {
            addCriterion("pass >=", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassLessThan(String value) {
            addCriterion("pass <", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassLessThanOrEqualTo(String value) {
            addCriterion("pass <=", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassLike(String value) {
            addCriterion("pass like", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassNotLike(String value) {
            addCriterion("pass not like", value, "pass");
            return (Criteria) this;
        }

        public Criteria andPassIn(List<String> values) {
            addCriterion("pass in", values, "pass");
            return (Criteria) this;
        }

        public Criteria andPassNotIn(List<String> values) {
            addCriterion("pass not in", values, "pass");
            return (Criteria) this;
        }

        public Criteria andPassBetween(String value1, String value2) {
            addCriterion("pass between", value1, value2, "pass");
            return (Criteria) this;
        }

        public Criteria andPassNotBetween(String value1, String value2) {
            addCriterion("pass not between", value1, value2, "pass");
            return (Criteria) this;
        }

        public Criteria andCustomeridIsNull() {
            addCriterion("customerID is null");
            return (Criteria) this;
        }

        public Criteria andCustomeridIsNotNull() {
            addCriterion("customerID is not null");
            return (Criteria) this;
        }

        public Criteria andCustomeridEqualTo(String value) {
            addCriterion("customerID =", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotEqualTo(String value) {
            addCriterion("customerID <>", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridGreaterThan(String value) {
            addCriterion("customerID >", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridGreaterThanOrEqualTo(String value) {
            addCriterion("customerID >=", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLessThan(String value) {
            addCriterion("customerID <", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLessThanOrEqualTo(String value) {
            addCriterion("customerID <=", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridLike(String value) {
            addCriterion("customerID like", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotLike(String value) {
            addCriterion("customerID not like", value, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridIn(List<String> values) {
            addCriterion("customerID in", values, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotIn(List<String> values) {
            addCriterion("customerID not in", values, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridBetween(String value1, String value2) {
            addCriterion("customerID between", value1, value2, "customerid");
            return (Criteria) this;
        }

        public Criteria andCustomeridNotBetween(String value1, String value2) {
            addCriterion("customerID not between", value1, value2, "customerid");
            return (Criteria) this;
        }

        public Criteria andIsvipIsNull() {
            addCriterion("IsVIP is null");
            return (Criteria) this;
        }

        public Criteria andIsvipIsNotNull() {
            addCriterion("IsVIP is not null");
            return (Criteria) this;
        }

        public Criteria andIsvipEqualTo(Integer value) {
            addCriterion("IsVIP =", value, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipNotEqualTo(Integer value) {
            addCriterion("IsVIP <>", value, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipGreaterThan(Integer value) {
            addCriterion("IsVIP >", value, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipGreaterThanOrEqualTo(Integer value) {
            addCriterion("IsVIP >=", value, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipLessThan(Integer value) {
            addCriterion("IsVIP <", value, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipLessThanOrEqualTo(Integer value) {
            addCriterion("IsVIP <=", value, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipIn(List<Integer> values) {
            addCriterion("IsVIP in", values, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipNotIn(List<Integer> values) {
            addCriterion("IsVIP not in", values, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipBetween(Integer value1, Integer value2) {
            addCriterion("IsVIP between", value1, value2, "isvip");
            return (Criteria) this;
        }

        public Criteria andIsvipNotBetween(Integer value1, Integer value2) {
            addCriterion("IsVIP not between", value1, value2, "isvip");
            return (Criteria) this;
        }

        public Criteria andAvailabelIsNull() {
            addCriterion("availabel is null");
            return (Criteria) this;
        }

        public Criteria andAvailabelIsNotNull() {
            addCriterion("availabel is not null");
            return (Criteria) this;
        }

        public Criteria andAvailabelEqualTo(Integer value) {
            addCriterion("availabel =", value, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelNotEqualTo(Integer value) {
            addCriterion("availabel <>", value, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelGreaterThan(Integer value) {
            addCriterion("availabel >", value, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelGreaterThanOrEqualTo(Integer value) {
            addCriterion("availabel >=", value, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelLessThan(Integer value) {
            addCriterion("availabel <", value, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelLessThanOrEqualTo(Integer value) {
            addCriterion("availabel <=", value, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelIn(List<Integer> values) {
            addCriterion("availabel in", values, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelNotIn(List<Integer> values) {
            addCriterion("availabel not in", values, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelBetween(Integer value1, Integer value2) {
            addCriterion("availabel between", value1, value2, "availabel");
            return (Criteria) this;
        }

        public Criteria andAvailabelNotBetween(Integer value1, Integer value2) {
            addCriterion("availabel not between", value1, value2, "availabel");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}